RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQL

نویسندگان

چکیده

One of the recent best attempts at Text-to-SQL is pre-trained language model. Due to structural property SQL queries, seq2seq model takes responsibility parsing both schema items (i.e., tables and columns) skeleton keywords). Such coupled targets increase difficulty correct queries especially when they involve many logic operators. This paper proposes a ranking-enhanced encoding skeleton-aware decoding framework decouple linking parsing. Specifically, for encoder-decode model, its encoder injected by most relevant instead whole unordered ones, which could alleviate effort during parsing, decoder first generates then actual query, implicitly constrain We evaluate our proposed on Spider three robustness variants: Spider-DK, Spider-Syn, Spider-Realistic. The experimental results show that delivers promising performance robustness. Our code available https://github.com/RUCKBReasoning/RESDSQL.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Coupled Schema Transformation and Data Conversion for XML and SQL

A two-level data transformation consists of a type-level transformation of a data format coupled with value-level transformations of data instances corresponding to that format. We have implemented a system for performing two-level transformations on XML schemas and their corresponding documents, and on SQL schemas and the databases that they describe. The core of the system consists of a combi...

متن کامل

An Adapter-Based Approach to Adapt Generated SQL in Model-to-Text Transformations to DB Schema Evolution

Forward Engineering advocates for code to be generated dynamically through model-to-text transformations that target a speci c platform. In this setting, platform evolution can leave the transformation, and hence the generated code, outdated. This issue is exacerbated by the perpetual beta phenomenon in Web 2.0 platforms where continuous delta releases are a common practice. Here, manual co-evo...

متن کامل

Optimizing Fixed-Schema XML to SQL Query Translation

Recently, there has been a lot of work on evaluating XML queries over data stored in relational database systems. The vast majority of this work has focused on the cases where either the relational schema is not fixed (so the problem is to find a good relational schema for a given XML workload) or the XML schema is not fixed (so the problem is to develop generic strategies for exporting XML vie...

متن کامل

A generator of SQL schema specifications

IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3 normal form with all relevant data constraints. SQL Generator is an IIS*Case tool t...

متن کامل

Querying the database using Schema-free SQL

Shema-free SQL takes into consideration two relaxations 1. Schema Relaxation: Users need not have to specify the exact name of the tables and attributes • Join Path: users need not have to specify the join path in the query Reducing user workload of writing SQL queries and knowing the complete database schema to query the RDBMS in order to get desired results Generation of Join Network (Interpr...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

ژورنال

عنوان ژورنال: Proceedings of the ... AAAI Conference on Artificial Intelligence

سال: 2023

ISSN: ['2159-5399', '2374-3468']

DOI: https://doi.org/10.1609/aaai.v37i11.26535